1 <?php
2 session_start();
3 error_reporting(0);
4 include('includes/config.php');
5 if(strlen($_SESSION['login'])==0)
6 {
7 header('location:index.php');
8 }
9 else{
10 ?>
11 <!DOCTYPE HTML>
12 <html>
13 <head>
14 <title>TMS | Tourism Management System</title>
15 <meta name="viewport" content="width=device-width, initial-scale=1">
16 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
17 <meta name="keywords" content="Tourism Management System In PHP" />
18 <script type="applijewelleryion/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
19 <link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
20 <link href="css/style.css" rel='stylesheet' type='text/css' />
21 <link href='//fonts.googleapis.com/css?family=Open+Sans:400,700,600' rel='stylesheet' type='text/css'>
22 <link href='//fonts.googleapis.com/css?family=Roboto+Condensed:400,700,300' rel='stylesheet' type='text/css'>
23 <link href='//fonts.googleapis.com/css?family=Oswald' rel='stylesheet' type='text/css'>
24 <link href="css/font-awesome.css" rel="stylesheet">
25 <!-- Custom Theme files -->
26 <script src="js/jquery-1.12.0.min.js"></script>
27 <script src="js/bootstrap.min.js"></script>
28 <!--animate-->
29 <link href="css/animate.css" rel="stylesheet" type="text/css" media="all">
30 <script src="js/wow.min.js"></script>
31 <script>
32 new WOW().init();
33 </script>
34
35 <style>
36 .errorWrap {
37 padding: 10px;
38 margin: 0 0 20px 0;
39 background: #fff;
40 border-left: 4px solid #dd3d36;
41 -webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
42 box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
43 }
44 .succWrap{
45 padding: 10px;
46 margin: 0 0 20px 0;
47 background: #fff;
48 border-left: 4px solid #5cb85c;
49 -webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
50 box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);
51 }
52 </style>
53 </head>
54 <body>
55 <!-- top-header -->
56 <div class="top-header">
57 <?php include('includes/header.php');?>
58 <div class="banner-1 ">
59 <div class="container">
60 <h1 class="wow zoomIn animated animated" data-wow-delay=".5s" style="visibility: visible; animation-delay: 0.5s; animation-name: zoomIn;">TMS-Tourism Management System</h1>
61 </div>
62 </div>
63 <!--- /banner-1 ---->
64 <!--- privacy ---->
65 <div class="privacy">
66 <div class="container">
67 <h3 class="wow fadeInDown animated animated" data-wow-delay=".5s" style="visibility: visible; animation-delay: 0.5s; animation-name: fadeInDown;">Issue Tickets</h3>
68 <form name="chngpwd" method="post" onSubmit="return valid();">
69 <?php if($error){?><div class="errorWrap"><strong>ERROR</strong>:<?php echo htmlentities($error); ?> </div><?php }
70 else if($msg){?><div class="succWrap"><strong>SUCCESS</strong>:<?php echo htmlentities($msg); ?> </div><?php }?>
71 <p>
72 <table border="1" width="100%">
73 <tr align="center">
74 <th>#</th>
75 <th>Ticket Id</th>
76 <th>Issue</th>
77 <th>Description</th>
78 <th>Admin Remark</th>
79 <th>Reg Date</th>
80 <th>Remark date</th>
81
82 </tr>
83 <?php
84
85 $uemail=$_SESSION['login'];;
86 $sql = "SELECT * from tblissues where UserEmail=:uemail";
87 $query = $dbh->prepare($sql);
88 $query -> bindParam(':uemail', $uemail, PDO::PARAM_STR);
89 $query->execute();
90 $results=$query->fetchAll(PDO::FETCH_OBJ);
91 $cnt=1;
92 if($query->rowCount() > 0)
93 {
94 foreach($results as $result)
95 { ?>
96 <tr align="center">
97 <td ><?php echo htmlentities($cnt);?></td>
98 <td width="100">#TKT-<?php echo htmlentities($result->id);?></td>
99 <td><?php echo htmlentities($result->Issue);?></td>
100 <td width="300"><?php echo htmlentities($result->Description);?></td>
101 <td><?php echo htmlentities($result->AdminRemark);?></td>
102 <td width="100"><?php echo htmlentities($result->PostingDate);?></td>
103 <td width="100"><?php echo htmlentities($result->AdminremarkDate);?></td>
104 </tr>
105 <?php $cnt=$cnt+1; }} ?>
106 </table>
107
108 </p>
109 </form>
110
111
112 </div>
113 </div>
114 <!--- /privacy ---->
115 <!--- footer-top ---->
116 <!--- /footer-top ---->
117 <?php include('includes/footer.php');?>
118 <!-- signup -->
119 <?php include('includes/signup.php');?>
120 <!-- //signu -->
121 <!-- signin -->
122 <?php include('includes/signin.php');?>
123 <!-- //signin -->
124 <!-- write us -->
125 <?php include('includes/write-us.php');?>
126 </body>
127 </html>
128 <?php } ?>